Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
PostalCodeID (PK) | A token identifier for a generic postal code. Postal codes vary in format, structure and content from one country to another. This generic ID ensures that each postal code is unique across ALL COUNTRIES. | ID_PSTL_CD | Identity | integer | |
PostalCode (AK) | Postal code value. In ARTS this is an alphanumeric attribute because unlike the US other countries use letters in their postal codes. | CD_PSTL | Code | varchar(20) | |
ISOCountryCode (AK)(FK) | The ISO-3166-1 two letter code denoting a locality in which the retailer does business. | CD_CY_ISO | Code2 | char(2) | ISO3166-1Country(LO_CY_ISO) |
PostalCodeDescription | PostalCode name or descriptioin | DE_PSTL_CD | DescriptionShort | varchar(255) | |
PostalCodeExtension (AK) | This is a second tier postal code that qualifies the PostalCode attribute and allows more precise mail sorting. It does not apply to all countries' postal codes. Also, it is usually not mandatory. So it can be omitted for business purposes. For data integrity purposes this attribute will be assigned a default values of all zeros so it can be treated as part of an unique alternate key. | CD_PSTL_EXTN | Code4External | char(4) | |